package com.example.entity.dto.pc;

import io.swagger.annotations.ApiModel;
import io.swagger.annotations.ApiModelProperty;
import lombok.Data;

@ApiModel(value = "物料平衡总表 列表Dto")
@Data
public class ListDto {

    @ApiModelProperty(value = "刷新数据库")
    private Boolean refreshDB;
    /**
     * WHERE LB=''需求'' AND (MB068 LIKE ''" + （工作中心）textBox1.Text + "%'' OR ''" + textBox1.Text + "''='''')
     * AND (A.MB025=''" + （品号属性）comboBox1.Text + "'' OR ''" + comboBox1.Text + "''='''')
     * AND ( A.ID like ''" + （品号起始于）textBox2.Text + "%'' OR ''" + textBox2.Text + "''='''')";
     * AND ( MB067=''" + （采购员）textBox3.Text + "'' OR ''" + textBox3.Text + "''='''')
     * AND (INVMB.MB017=''" + （主要仓库）textBox11.Text + "'' OR ''" + textBox11.Text + "''='''')
     * AND (A.MB002 LIKE ''%" + （品名规格）textBox7.Text + "%'' OR A.MB003 LIKE ''%" + textBox7.Text + "%''
     * 	OR ''" + textBox7.Text + "''='''')
     * AND TC012 LIKE ''%" + （订单单号）textBox8.Text + "%''
     * AND (EXISTS(SELECT * FROM PURTD LEFT JOIN PURTC ON TD001=TC001 AND TD002=TC002
     * 	WHERE TD016=''N'' AND TD004=A.ID AND TC004=''" + （供应商编号）textBox10.Text + "'') OR ''" + textBox10.Text + "''='''')
     */
    @ApiModelProperty(value = "工作中心")
    private String workCenter;

    @ApiModelProperty(value = "品号属性")
    private String productType;

    @ApiModelProperty(value = "品号起始于")
    private String productIdStart;

    @ApiModelProperty(value = "采购员")
    private String buyer;

    @ApiModelProperty(value = "主要仓库")
    private String mainWarehouse;

    @ApiModelProperty(value = "品名规格")
    private String productSpecifications;

    @ApiModelProperty(value = "订单单号")
    private String orderId;

    @ApiModelProperty(value = "供应商编号")
    private String supplierId;

    @ApiModelProperty(value = "日期起始 YYYYMMDD")
    private String timeStart;

    @ApiModelProperty(value = "日期结束 YYYYMMDD")
    private String timeEnd;

}
